package com.vegetable.modules.mapper.wx;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.vegetable.modules.entity.wx.WXApproval;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

/**
 * 用户与角色对应关系
 *
 * @author Mark sunlightcs@gmail.com
 */
@Mapper
public interface WXApprovalDao extends BaseMapper<WXApproval> {
    
    /**
     * 根据审批编号查询审批记录
     * 
     * @param spNo 审批编号
     * @return 审批记录
     */
    @Select("SELECT * FROM wx_approval WHERE sp_no = #{spNo} LIMIT 1")
    WXApproval selectBySpNo(String spNo);
}